This appendix contains sample reports.
Inventory Transaction Register
Date 06/04/1999 Time 15:42:04 XYZ Company Report #0197 Page 0001
I N V E N T O R Y T R A N S A C T I O N R E G I S T E R
Current period ending date: 1/31/99
Inventory valuation method: LIFO
------------------------------------------------------------------------------------------------------------------------------------
Item-# Description Date Type Doc-# Trans-qty Price-1 Price-2 Price-3
Level-# Actual-cost Whs Loc Comment Price-4 Price-5
------------------------------------------------------------------------------------------------------------------------------------
1 Drill, 1/4” Power Hand 6/04/99 Recv 23 24 55.00 53.50 51.00
22.50 Cen PO 16 0.00 0.00
Running-qty-oh: 419
Total actual cost: 540.00
Layer added: 6/04/99 24 EACH at 22.50 cost
1 Receiving Total quantity received: 24
-----------------------------------------------------------------------------------------
Date 06/04/1999 Time 15:42:04 XYZ Company Report #0197 Page 0002
I N V E N T O R Y T R A N S A C T I O N R E G I S T E R
Total receiving entries: 1 Total qty received: 24 Total actual cost of receivings: 540.00
Total credit memo entries: 0 Total credit memo qty: 0 Total value of credit memos: 0.00
Total actual cost of credit memos: 0.00
Credit memo margin: 0.00
Total transfer entries: 0 Total qty transferred: 0
Total up adj entries: 0 Total qty adjusted: 0 Total actual cost of upward adj: 0.00
Total down adj entries: 0 Total qty adjusted: 0 Total actual cost of downward adj: 0.00
Total sale entries: 0 Total sale qty: 0 Total value of sales: 0.00
Total actual cost of sales: 0.00
Sales margin: 0.00
Total component usage Total actual cost of
entries for kit assembly: 0 Total comp qty used: 0 inventory used as components: 0.00
Total kit assembly entries: 0 Total kit qty assmbled: 0 Total actual cost of kit assembly: 0.00
-- End of report --
Date 06/04/1999 Time 11:35:52 XYZ Company Report #0183 Page 0001
D E L I V E R - T O L O C A T I O N S
------------------------------------------------------------------------------------------------------------------------------------
Location code Location name Address
------------------------------------------------------------------------------------------------------------------------------------
Central Central 300 Central Ave
Nashua, NH 03345
1 Main XYZ Company
101 Buckley
Market Center Depot
Anytown, Texas 12345
Attn: Shipping Clerk
2 South 450 South Avenue
Concord, NH 03311
3 locations on file
-- End of report --
Date 06/04/1999 Time 11:38:09 XYZ Company Report #0184 Page 0001
V E N D O R I T E M L I S T
Starting vendor #: “First” Ending vendor #: “Last”
“Qdsc?” = subject to quantity discounts ? “Pdsc?” = subject to price discounts ? “Spc?” = subject to special terms ?
------------------------------------------------------------------------------------------------------------------------------------
Our-item-# Our-item-description-1 Vendor’s-prod-# Vendor’s-product-desc-1 Vendor-unit Unit-price Lead-days
Our-item-description-2 Qdsc? Pdsc? Spc? Vendor’s-product-desc-2 -Sell/Ship- Min-order Vendor-rank
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 100 Vermont Metal Products Contact-1: John Smith Contact-2: Howard Brice
410 Pinecrest Road Phone-1: 802-445-9134 Phone-2: 802-445-9136
Newton VT 12345
*TEMP Temporary Item *TEMP Temporary Item EACH .00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
1 Drill, 1/4” Power Hand 1 Drill, 1/4” Power Hand EACH 22.50 5
Y N Y CASE 12 Prime vendor
Our stocking unit: EACH Unit conversion: 1 CASE = 12 EACH Comment: Check orders with Tom
Last PO: 9 P.O. date: 1/21/99 Qty: 25
2 Hammer, 16 oz. Claw 2 Hammer, 16 oz. Claw EACH 9.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
3 Wrench, 3/8” Socket Set 3 Wrench, 3/8” Socket Set EACH 8.50 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
5 Chisel, 5 pc Set 5 Chisel, 5 pc Set EACH 5.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 9 P.O. date: 1/21/99 Qty: 100
6 Motor, 2hp Submersible 6 Motor, 2hp Submersible EACH 55.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 4 P.O. date: 1/18/99 Qty: 50
7 Gauge, Hi-pressure 7 Gauge, Hi-pressure EACH 6.59 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 19 P.O. date: 1/20/99 Qty: 450
8 1” Steel Bolts 8 1” Steel Bolts EACH .20 0
N N N EACH 0 Prime vendor
Our stocking unit: CASE Unit conversion: 1 EACH = 1 EACH
1 EACH = 1 CASE
100 Extended Warranty 100 Extended Warranty EACH 15.00 0
90 Day Warranty N N N 90 Day Warranty EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Date 06/04/1999 Time 11:38:09 XYZ Company Report #0184 Page 0002
V E N D O R I T E M L I S T
------------------------------------------------------------------------------------------------------------------------------------
Our-item-# Our-item-description-1 Vendor’s-prod-# Vendor’s-product-desc-1 Vendor-unit Unit-price Lead-days
Our-item-description-2 Qdsc? Pdsc? Spc? Vendor’s-product-desc-2 -Sell/Ship- Min-order Vendor-rank
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 100 Vermont Metal Products (Continued)
1000 Starter Tool Set 1000 Starter Tool Set EACH 34.50 0
Kit Item N N N Kit Item EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 200 Acme Office Supplies Contact-1: Barb Caldwell Contact-2:
456 N. Broadway Phone-1: 213-999-9765 Phone-2:
Los Angeles CA 90101
2 Hammer, 16 oz. Claw 2 Hammer, 16 oz. Claw EACH 9.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 10 P.O. date: 1/21/99 Qty: 125
3 Wrench, 3/8” Socket Set 3 Wrench, 3/8” Socket Set EACH 8.50 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
5 Chisel, 5 pc Set 5 Chisel, 5 pc Set EACH 5.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
6 Motor, 2hp Submersible 6 Motor, 2hp Submersible EACH 55.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
7 Gauge, Hi-pressure 7 Gauge, Hi-pressure EACH 6.59 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 2 P.O. date: 1/21/99 Qty: 250
8 1” Steel Bolts 8 1” Steel Bolts EACH .20 0
N N N EACH 0 Prime vendor
Our stocking unit: CASE Unit conversion: 1 EACH = 1 EACH
1 EACH = 1 CASE
Last PO: 10 P.O. date: 1/21/99 Qty: 2,500
100 Extended Warranty 100 Extended Warranty EACH 15.00 0
90 Day Warranty N N N 90 Day Warranty EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
1000 Starter Tool Set 1000 Starter Tool Set EACH 34.50 0
Date 06/04/1999 Time 11:38:09 XYZ Company Report #0184 Page 0003
V E N D O R I T E M L I S T
------------------------------------------------------------------------------------------------------------------------------------
Our-item-# Our-item-description-1 Vendor’s-prod-# Vendor’s-product-desc-1 Vendor-unit Unit-price Lead-days
Our-item-description-2 Qdsc? Pdsc? Spc? Vendor’s-product-desc-2 -Sell/Ship- Min-order Vendor-rank
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 300 Red Line Freight Contact-1: Carl Rawlings Contact-2: Lucy Mason
22748 E. Commercial Phone-1: 213-768-7650 Phone-2: 213-768-7660
Los Angeles CA 92251
2 Hammer, 16 oz. Claw 2 Hammer, 16 oz. Claw EACH 9.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
3 Wrench, 3/8” Socket Set 3 Wrench, 3/8” Socket Set EACH 8.50 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
5 Chisel, 5 pc Set 5 Chisel, 5 pc Set EACH 5.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
6 Motor, 2hp Submersible 6 Motor, 2hp Submersible EACH 55.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
7 Gauge, Hi-pressure 7 Gauge, Hi-pressure EACH 6.59 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 25 P.O. date: 1/20/99 Qty: 300
8 1” Steel Bolts 8 1” Steel Bolts EACH .20 0
N N N EACH 0 Prime vendor
Our stocking unit: CASE Unit conversion: 1 EACH = 1 EACH
1 EACH = 1 CASE
100 Extended Warranty 100 Extended Warranty EACH 15.00 0
90 Day Warranty N N N 90 Day Warranty EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
1000 Starter Tool Set 1000 Starter Tool Set EACH 34.50 0
Kit Item N N N Kit Item EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
------------------------------------------------------------------------------------------------------------------------------------
Date 06/04/1999 Time 11:38:09 XYZ Company Report #0184 Page 0004
V E N D O R I T E M L I S T
------------------------------------------------------------------------------------------------------------------------------------
Our-item-# Our-item-description-1 Vendor’s-prod-# Vendor’s-product-desc-1 Vendor-unit Unit-price Lead-days
Our-item-description-2 Qdsc? Pdsc? Spc? Vendor’s-product-desc-2 -Sell/Ship- Min-order Vendor-rank
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 400 Jones Property Management (Continued)
3 Wrench, 3/8” Socket Set 3 Wrench, 3/8” Socket Set EACH 8.50 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
5 Chisel, 5 pc Set 5 Chisel, 5 pc Set EACH 5.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
6 Motor, 2hp Submersible 6 Motor, 2hp Submersible EACH 55.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 28 P.O. date: 1/20/99 Qty: 3
7 Gauge, Hi-pressure 7 Gauge, Hi-pressure EACH 6.59 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 11 P.O. date: 1/18/99 Qty: 300
8 1” Steel Bolts 8 1” Steel Bolts EACH .20 0
N N N EACH 0 Prime vendor
Our stocking unit: CASE Unit conversion: 1 EACH = 1 EACH
1 EACH = 1 CASE
Last PO: 28 P.O. date: 1/20/99 Qty: 3
100 Extended Warranty 100 Extended Warranty EACH 15.00 0
90 Day Warranty N N N 90 Day Warranty EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
1000 Starter Tool Set 1000 Starter Tool Set EACH 34.50 0
Kit Item N N N Kit Item EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 500 E-Z Repairs Contact-1: Betty Smith Contact-2: Sandra Kitts
900 S. Vermont Avenue Phone-1: 213-695-2101 Phone-2: 213-695-2102
Los Angeles CA 90005
2 Hammer, 16 oz. Claw 2 Hammer, 16 oz. Claw EACH 9.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
3
Date 06/04/1999 Time 11:38:09 XYZ Company Report #0184 Page 0005
V E N D O R I T E M L I S T
------------------------------------------------------------------------------------------------------------------------------------
Our-item-# Our-item-description-1 Vendor’s-prod-# Vendor’s-product-desc-1 Vendor-unit Unit-price Lead-days
Our-item-description-2 Qdsc? Pdsc? Spc? Vendor’s-product-desc-2 -Sell/Ship- Min-order Vendor-rank
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 500 E-Z Repairs (Continued)
5 Chisel, 5 pc Set 5 Chisel, 5 pc Set EACH 5.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
6 Motor, 2hp Submersible 6 Motor, 2hp Submersible EACH 55.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
7 Gauge, Hi-pressure 7 Gauge, Hi-pressure EACH 6.59 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 16 P.O. date: 1/18/99 Qty: 300
8 1” Steel Bolts 8 1” Steel Bolts EACH .20 0
N N N EACH 0 Prime vendor
Our stocking unit: CASE Unit conversion: 1 EACH = 1 EACH
1 EACH = 1 CASE
100 Extended Warranty 100 Extended Warranty EACH 15.00 0
90 Day Warranty N N N 90 Day Warranty EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
1000 Starter Tool Set 1000 Starter Tool Set EACH 34.50 0
Kit Item N N N Kit Item EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 600 Wells Fargo Bank Contact-1: Jack Dawson Contact-2: Mary Andrews
Mason/Beverly Branch Phone-1: 213-695-4670 Phone-2: 213-695-4680
4031 N. Mason
Los Angeles CA 91206
2 Hammer, 16 oz. Claw 2 Hammer, 16 oz. Claw EACH 9.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
3 Wrench, 3/8” Socket Set 3 Wrench, 3/8” Socket Set EACH 8.50 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
5 Chisel, 5 pc Set 5 Chisel, 5 pc Set EACH 5.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Date 06/04/1999 Time 11:38:09 XYZ Company Report #0184 Page 0006
V E N D O R I T E M L I S T
------------------------------------------------------------------------------------------------------------------------------------
Our-item-# Our-item-description-1 Vendor’s-prod-# Vendor’s-product-desc-1 Vendor-unit Unit-price Lead-days
Our-item-description-2 Qdsc? Pdsc? Spc? Vendor’s-product-desc-2 -Sell/Ship- Min-order Vendor-rank
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 600 Wells Fargo Bank (Continued)
6 Motor, 2hp Submersible 6 Motor, 2hp Submersible EACH 55.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
7 Gauge, Hi-pressure 7 Gauge, Hi-pressure EACH 6.59 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
8 1” Steel Bolts 8 1” Steel Bolts EACH .20 0
N N N EACH 0 Prime vendor
Our stocking unit: CASE Unit conversion: 1 EACH = 1 EACH
1 EACH = 1 CASE
100 Extended Warranty 100 Extended Warranty EACH 15.00 0
90 Day Warranty N N N 90 Day Warranty EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
1000 Starter Tool Set 1000 Starter Tool Set EACH 34.50 0
Kit Item N N N Kit Item EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 700 Pacific Telephone Contact-1: Thomas Brock Contact-2:
Glendale Office Phone-1: 818-221-1213 Phone-2:
500 N. Central
Glendale CA 91206
2 Hammer, 16 oz. Claw 2 Hammer, 16 oz. Claw EACH 9.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
3 Wrench, 3/8” Socket Set 3 Wrench, 3/8” Socket Set EACH 8.50 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
5 Chisel, 5 pc Set 5 Chisel, 5 pc Set EACH 5.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
6 Motor, 2hp Submersible 6 Motor, 2hp Submersible EACH 55.00 0
N N N EACH 0 Prime vendor
Date 06/04/1999 Time 11:38:09 XYZ Company Report #0184 Page 0007
V E N D O R I T E M L I S T
------------------------------------------------------------------------------------------------------------------------------------
Our-item-# Our-item-description-1 Vendor’s-prod-# Vendor’s-product-desc-1 Vendor-unit Unit-price Lead-days
Our-item-description-2 Qdsc? Pdsc? Spc? Vendor’s-product-desc-2 -Sell/Ship- Min-order Vendor-rank
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 700 Pacific Telephone (Continued)
8 1” Steel Bolts 8 1” Steel Bolts EACH .20 0
N N N EACH 0 Prime vendor
Our stocking unit: CASE Unit conversion: 1 EACH = 1 EACH
1 EACH = 1 CASE
100 Extended Warranty 100 Extended Warranty EACH 15.00 0
90 Day Warranty N N N 90 Day Warranty EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
1000 Starter Tool Set 1000 Starter Tool Set EACH 34.50 0
Kit Item N N N Kit Item EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 800 Hanson Manufacturing Co. Contact-1: Don Barber Contact-2: Hanna Wendall
65 Industrial Circle Phone-1: 847-669-8560 Phone-2: 847-669-8564
Chicago IL 30555
1 Drill, 1/4” Power Hand PD-14 Power Drill EACH 12.00 7
N N N EACH 1 Second choice
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
4 Saw, 2hp 7 1/4” Circular SAW-7-25-C Saw, 2hp 7 1/4” Circular EACH 18.00 0
N N N EACH 0 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 12 P.O. date: 1/21/99 Qty: 25
6 Motor, 2hp Submersible 2HP-MOTOR Motor, 2hp Submersible EACH 55.00 0
N N N EACH 5 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 12 P.O. date: 1/21/99 Qty: 15
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 900 Reynolds Tool Company Contact-1: Bill Ryan Contact-2:
Attn: Accts Receivable Phone-1: 970-447-8900 Phone-2:
3922 Frontier Parkway
Denver CO 85366
5 Chisel, 5 pc Set SET-CHISEL Chisel, 5 pc Set EACH 6.50 0
N N N EACH 25 Prime vendor
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 8 P.O. date: 1/18/99 Qty: 240
Date 06/04/1999 Time 11:38:09 XYZ Company Report #0184 Page 0008
V E N D O R I T E M L I S T
------------------------------------------------------------------------------------------------------------------------------------
Our-item-# Our-item-description-1 Vendor’s-prod-# Vendor’s-product-desc-1 Vendor-unit Unit-price Lead-days
Our-item-description-2 Qdsc? Pdsc? Spc? Vendor’s-product-desc-2 -Sell/Ship- Min-order Vendor-rank
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 1000 Greener Grass Ofc. Plants Contact-1: Bernard Maybeck Contact-2: Mabel Saunders
324 N Winter Dr. Phone-1: 714-555-2344 Phone-2: 714-555-2351
Los Angeles CA 90210
7 Gauge, Hi-pressure 7 Gauge, Hi-pressure EACH 6.59 7
N N N EACH 1 Second choice
Our stocking unit: EACH Unit conversion: 1 EACH = 1 EACH
Last PO: 13 P.O. date: 1/21/99 Qty: 450
------------------------------------------------------------------------------------------------------------------------------------
-- End of report --
Date 06/04/1999 Time 11:51:40 XYZ Company Report #0185 Page 0001
B R I E F V E N D O R I T E M L I S T
Vendor: 100 Vermont Metal Products Contact-1: John Smith Contact-2: Howard Brice
410 Pinecrest Road Phone-1: 802-445-9134 Phone-2: 802-445-9136
Newton VT 12345
------------------------------------------------------------------------------------------------------------------------------------
Item-# Vendor-product-descr-1 Vendor-product-descr-2 Vendor-prod-# Vendor-rank
------------------------------------------------------------------------------------------------------------------------------------
*TEMP Temporary Item *TEMP 1
1 Drill, 1/4” Power Hand 1 1
2 Hammer, 16 oz. Claw 2 1
3 Wrench, 3/8” Socket Set 3 1
5 Chisel, 5 pc Set 5 1
6 Motor, 2hp Submersible 6 1
7 Gauge, Hi-pressure 7 1
8 1” Steel Bolts 8 1
100 Extended Warranty 90 Day Warranty 100 1
1000 Starter Tool Set Kit Item 1000 1
-- End of report --
Date 06/04/1999 Time 13:24:45 XYZ Company Report #0186 Page 0001
P U R C H A S I N G A D D R E S S E S
Starting vendor #: “First”
Ending vendor #: “Last”
------------------------------------------------------------------------------------------------------------------------------------
Vend-# Name Loc-# Loc-name Contact-1 Contact-2
Address Loc-address Phone Phone
Fax Fax
E-mail E-mail
------------------------------------------------------------------------------------------------------------------------------------
300 Red Line Freight 1-002 Red Line Freight Tim Rawlings
22748 E. Commercial Building 4-D 213-555-9933
Los Angeles, CA 92251 1000 Industrial Park Rd.
Country: USA Los Angeles, CA 92251
Country: USA
All PO’s to this address
700 Pacific Telephone LA Los Angeles Office Mike Douglas
Glendale Office 322 Independence Way 813-908-4444
500 N. Central Los Angeles, CA 90210
Glendale, CA 91206 Country: USA
Country: USA
We sometimes pay here if the check gets dropped off by hand.
800 Hanson Manufacturing Co. NW Northwest Office Gregory Hines
65 Industrial Circle 2344 W. Hoodview 833-877-8832
Chicago, IL 30555 Portland OR 97332
Country: USA Country: USA
This is our second choice in terms of quick shipments.
RM Rocky Mountains Office William Hurt
4500 Boulder 609-332-4478
Denver, CO 80504
Country: USA
5 Purchasing addresses on file
-- End of report --
Date 06/04/1999 Time 13:29:30 XYZ Company Report #0187 Page 0001
A V A I L A B L E P . O . N U M B E R S
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# Vendor Vendor-name Date Comments
------------------------------------------------------------------------------------------------------------------------------------
15 ______ _________________________ ________ __________________________________________________________________
16 ______ _________________________ ________ __________________________________________________________________
17 ______ _________________________ ________ __________________________________________________________________
18 ______ _________________________ ________ __________________________________________________________________
19 ______ _________________________ ________ __________________________________________________________________
20 ______ _________________________ ________ __________________________________________________________________
21 ______ _________________________ ________ __________________________________________________________________
22 ______ _________________________ ________ __________________________________________________________________
23 ______ _________________________ ________ __________________________________________________________________
24 ______ _________________________ ________ __________________________________________________________________
-- End of report --
Date 06/04/1999 Time 13:31:58 XYZ Company Report #0188 Page 0001
P U R C H A S I N G A D V I C E R E P O R T
In order by: Vendor Starting item: “First” Product cat / sub-cat: “All” / “All” Starting vendor: “First”
Warehouse: “All” Ending item: “Last” Vendor type: “All” Ending vendor: “Last”
Negative “Qty-commtd” means that there are unposted receiving transactions on file for the item.
------------------------------------------------------------------------------------------------------------------------------------
Item-# / Vendor-item-# Qty-on-hnd Reordr-lvl Qty-commtd Prev-prd-sales Sls-YTD Rplc-cost Hit-RO
Description Unit Qty-on-ord Max-qty Qty-bakord Prd Qty Avg-per-prd Value-OH Min-ord
OH + On-ord Qty-PTD #-weeks-OH Price-1 Max-ord
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 100 Vermont Metal Products 802-445-9134 John Smith 802-445-9136 Howard Brice
7 /7 771 1,000 0 154 6.59 Y
Gauge, Hi-pressure EACH 0 9,200 0 5,080.89 229.00
771 154 19.50 8,429.00
-- End of report --
Date 06/04/1999 Time 13:34:39 XYZ Company Report #0189 Page 0001
P U R C H A S I N G W O R K S H E E T 0 0 0 1
Item: 1 Drill, 1/4” Power Hand On hand: 395 ---Prev-prd-usage--
(+) On order: 25 Prd Quantity
Stocking unit: EACH (-) Committed: 2
----------------------
Reorder level: 175 Remainder available: 418
Maximum inventory qty: 1,650 On back-order: 0
------------------------------------------------------------------------------------------------------------------------------------
Warehouse Qty-on-hnd Qty-on-ord Qty-commtd Qty-backord Prev-1-prd Prev-2-prd Prev-3-prd Prev-4-prd Avg-prd-use Wks-OH
Central 245 0 1 0 0 0 0 0
Main 150 0 1 0 0 0 0 0
South 0 25 0 0 0 0 0 0
------------------------------------------------------------------------------------------------------------------------------------
Number Name Vendor’s item-# Vendor’s product descr Unit Lead time: 5 Qty disc? Y
Vendor: 100 Vermont Metal Products 1 Drill, 1/4” Power Hand Sell: EACH Vndr rank: 1 Price disc? N
Ship: CASE Check orders with Tom
Contact-1/Phone-1: John Smith 802-445-9134 Contact-2/Phone-2: Howard Brice 802-445-9136
P.O.# Date Quantity Unit-price
Last P.O.:9 1/21/99 25 EACH 12.00 EACH 1 CASE = 12 EACH List prc: 55
Open P.O.s:NONE Min qty: 12
------------------------------------------------------------------------------------------------------------------------------------
Number Name Vendor’s item-# Vendor’s product descr Unit Lead time: 5 Qty disc? Y
Vendor: 200 Acme Office Supplies 1 Drill, 1/4” Power Hand Sell: EACH Vndr rank: 2 Price disc? N
Ship: CASE Check orders with Tom
Contact-1/Phone-1: Barb Caldwell 213-999-9765
P.O.# Date Quantity Unit-price
Last P.O.:None 1 CASE = 12 EACH List prc: 55
Min qty: 12
------------------------------------------------------------------------------------------------------------------------------------
Number Name Vendor’s item-# Vendor’s product descr Unit Lead time: 7 Qty disc? N
Vendor: 800 Hanson Manufacturing Co. PD-14 Power Drill Sell: EACH Vndr rank: 2 Price disc? N
Ship: EACH
Contact-1/Phone-1: Don Barber 847-669-8560 Contact-2/Phone-2: Hanna Wendall 847-669-8564
P.O.# Date Quantity Unit-price
Last P.O.:None List prc: 55
Min qty: 1
------------------------------------------------------------------------------------------------------------------------------------
Date 06/04/1999 Time 13:34:39 XYZ Company Report #0189 Page 0002
P U R C H A S I N G W O R K S H E E T 0 0 0 1
This P.O.: P.O.-# _______________ Vendor ______ _________________________ Deliver-to _________________________
_________________________ _________________________
Date ________ _________________________ _________________________
F.O.B. _______________ _________________________ _________________________
Ship-via _______________
Ordered by _______________ Confirming order ? Yes No Internal-use Don’t-print
Special terms ____________________________
Special msg __________________________________________________ Multi-drop ? _
Qty ordered ____________ unit ____ __________________________________________________ Blanket ? _
Unit price ____________ per ____ __________________________________________________ Release every _____
Location Date Quantity Expedite-days G/L-Acct Qty/Pct/Amt
Delivery sched __________ ________ __________ ___ Distribution ________ ___________
__________ ________ __________ ___ ________ ___________
__________ ________ __________ ___ ________ ___________
__________ ________ __________ ___ ________ ___________
Date 06/04/1999 Time 13:34:40 XYZ Company Report #0189 Page 0001
W O R K S H E E T I N D E X
Vendor: 100 Vermont Metal Products Contact-1: John Smith Contact-2: Howard Brice
410 Pinecrest Road Phone-1: 802-445-9134 Phone-2: 802-445-9136
Newton VT 12345
Our-item-# Our-item-description Wksht# Vendor’s item-# Vendor’s product descr
1 Drill, 1/4” Power Hand 0001 1 Drill, 1/4” Power Hand
2 Hammer, 16 oz. Claw 0002 2 Hammer, 16 oz. Claw
3 Wrench, 3/8” Socket Set 0003 3 Wrench, 3/8” Socket Set
5 Chisel, 5 pc Set 0005 5 Chisel, 5 pc Set
6 Motor, 2hp Submersible 0006 6 Motor, 2hp Submersible
7 Gauge, Hi-pressure 0007 7 Gauge, Hi-pressure
8 1” Steel Bolts 0008 8 1” Steel Bolts
100 Extended Warranty 0009 100 Extended Warranty
90 Day Warranty 90 Day Warranty
1000 Starter Tool Set 0010 1000 Starter Tool Set
Kit Item Kit Item
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 200 Acme Office Supplies Contact-1: Barb Caldwell Contact-2:
456 N. Broadway Phone-1: 213-999-9765 Phone-2:
Los Angeles CA 90101
Our-item-# Our-item-description Wksht# Vendor’s item-# Vendor’s product descr
1 Drill, 1/4” Power Hand 0001 1 Drill, 1/4” Power Hand
2 Hammer, 16 oz. Claw 0002 2 Hammer, 16 oz. Claw
3 Wrench, 3/8” Socket Set 0003 3 Wrench, 3/8” Socket Set
5 Chisel, 5 pc Set 0005 5 Chisel, 5 pc Set
6 Motor, 2hp Submersible 0006 6 Motor, 2hp Submersible
7 Gauge, Hi-pressure 0007 7 Gauge, Hi-pressure
8 1” Steel Bolts 0008 8 1” Steel Bolts
100 Extended Warranty 0009 100 Extended Warranty
90 Day Warranty 90 Day Warranty
1000 Starter Tool Set 0010 1000 Starter Tool Set
Kit Item Kit Item
------------------------------------------------------------------------------------------------------------------------------------
Date 06/04/1999 Time 13:34:40 XYZ Company Report #0189 Page 0002
W O R K S H E E T I N D E X
Vendor: 300 Red Line Freight Contact-1: Carl Rawlings Contact-2: Lucy Mason
22748 E. Commercial Phone-1: 213-768-7650 Phone-2: 213-768-7660
Los Angeles CA 92251
Our-item-# Our-item-description Wksht# Vendor’s item-# Vendor’s product descr
2 Hammer, 16 oz. Claw 0002 2 Hammer, 16 oz. Claw
3 Wrench, 3/8” Socket Set 0003 3 Wrench, 3/8” Socket Set
5 Chisel, 5 pc Set 0005 5 Chisel, 5 pc Set
6 Motor, 2hp Submersible 0006 6 Motor, 2hp Submersible
7 Gauge, Hi-pressure 0007 7 Gauge, Hi-pressure
8 1” Steel Bolts 0008 8 1” Steel Bolts
100 Extended Warranty 0009 100 Extended Warranty
90 Day Warranty 90 Day Warranty
1000 Starter Tool Set 0010 1000 Starter Tool Set
Kit Item Kit Item
----------------------------------------------------------------------------------------------------------------------------------
Date 06/04/1999 Time 13:36:45 XYZ Company Report #0190 Page 0001
P R E - P U R C H A S E O R D E R
Starting item-# : “First” Ending item-# : “Last”
Starting vendor-#: “First” Ending vendor-#: “Last”
------------------------------------------------------------------------------------------------------------------------------------
Vendor Vendor name Whs Item-# Description-1 Qty Price Selected ? Vendor-item-#
------------------------------------------------------------------------------------------------------------------------------------
100 Vermont Metal Products 7 Gauge, Hi-pressure 229 6.59 N 7
1 Pre-purchase order on file
-- End of report --
Date 06/04/1999 Time 14:40:04 XYZ Company Report #0191 Page 0001
P U R C H A S E O R D E R E D I T L I S T
P.O. range: “First” to “Last” (All P.O.’s in the range are shown.)
Adrs-# = Purchasing address location if different from vendor’s remittance address
Confrm? = Confirming order status: Y = Confirming order N = Not a confirming order I = Internal use only D = Don’t print
Ex-days = Number of days before required date that this delivery should be expedited
Items can be ordered for: INVENTORY or OTHER
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# PO-date Vendor Name F.O.B. Ship-via Ordered by Deliver-to
Printed? Adrs-# Address Special terms Confrm? Multi-drop?
------------------------------------------------------------------------------------------------------------------------------------
15 6/04/99 100 Vermont Metal Products Our dock UPS Ground Beth Central
No Y N
------------------------------------------------------------------------------------------------------------------------------------
Seq# Our-item-# Our description Vendor-prod-# Vendor’s description Qty-ord Unit Unit-price
Worksheet # Unit-conversion Sell-UM Ship-UM Ordrd-for Ext-price
Reqd-date Ship-qty Ex-days
------------------------------------------------------------------------------------------------------------------------------------
10 7 Gauge, Hi-pressure 7 Gauge, Hi-pressure 229 EACH 6.59 EACH
EACH EACH INVENTORY 1,509.11
6/04/99 229
Acct-# Description Quantity
Accounting distributions: 5070-000 Inventory expenses 229
1 lines Total P.O. amount = 1,509.11
*** THIS P.O. MUST BE PRINTED BEFORE POSTING IS ALLOWED ***
------------------------------------------------------------------------------------------------------------------------------------
Date 06/04/1999 Time 14:40:04 XYZ Company Report #0191 Page 0002
P U R C H A S E O R D E R E D I T L I S T
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# PO-date Vendor Name F.O.B. Ship-via Ordered by Deliver-to
Printed? Adrs-# Address Special terms Confrm? Multi-drop?
------------------------------------------------------------------------------------------------------------------------------------
16 6/04/99 100 Vermont Metal Products Our dock UPS Ground Beth Central
No Net 60 Days Y N
Special msg: Deliveries are now being taken on the
east end of the building. Thank you.
------------------------------------------------------------------------------------------------------------------------------------
Seq# Our-item-# Our description Vendor-prod-# Vendor’s description Qty-ord Unit Unit-price
Worksheet # Unit-conversion Sell-UM Ship-UM Ordrd-for Ext-price
Reqd-date Ship-qty Ex-days
------------------------------------------------------------------------------------------------------------------------------------
10 1 Drill, 1/4” Power Hand 1 Drill, 1/4” Power Hand 12 EACH 22.50 EACH
1 CASE = 12 EACH EACH CASE INVENTORY 270.00
6/09/99 12 5
Note-# Text
10 If unavailable please do not substitute
Acct-# Description Quantity
Accounting distributions: 5070-000 Inventory expenses 12
1 lines Total P.O. amount = 270.00
*** THIS P.O. MUST BE PRINTED BEFORE POSTING IS ALLOWED ***
------------------------------------------------------------------------------------------------------------------------------------
2 P.O.’s 2 total lines Grand total P.O. amount = 1,779.11
-- End of report --
Date 06/04/1999 Time 14:46:13 XYZ Company Report #0192 Page 0001
P U R C H A S E O R D E R R E G I S T E R
P.O. range: “First” to “Last”
Adrs-# = Purchasing address location if different from vendor’s remittance address
Confrm? = Confirming order status: Y = Confirming order N = Not a confirming order I = Internal use only D = Don’t print
Ex-days = Number of days before required date that this delivery should be expedited
Items can be ordered for: INVENTORY or OTHER
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# PO-date Vendor Name F.O.B. Ship-via Ordered by Deliver-to
Printed? Adrs-# Address Special terms Confrm? Multi-drop?
------------------------------------------------------------------------------------------------------------------------------------
15 6/04/99 100 Vermont Metal Products Our dock UPS Ground Beth Central
Yes Y N
------------------------------------------------------------------------------------------------------------------------------------
Seq# Our-item-# Our description Vendor-prod-# Vendor’s description Qty-ord Unit Unit-price
Worksheet # Unit-conversion Sell-UM Ship-UM Ordrd-for Ext-price
Reqd-date Ship-qty Ex-days
------------------------------------------------------------------------------------------------------------------------------------
10 7 Gauge, Hi-pressure 7 Gauge, Hi-pressure 229 EACH 6.59 EACH
EACH EACH INVENTORY 1,509.11
6/04/99 229
Acct-# Description Quantity
Accounting distributions: 5070-000 Inventory expenses 229
1 lines Total P.O. amount = 1,509.11
------------------------------------------------------------------------------------------------------------------------------------
Date 06/04/1999 Time 14:46:13 XYZ Company Report #0192 Page 0002
P U R C H A S E O R D E R R E G I S T E R
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# PO-date Vendor Name F.O.B. Ship-via Ordered by Deliver-to
Printed? Adrs-# Address Special terms Confrm? Multi-drop?
------------------------------------------------------------------------------------------------------------------------------------
16 6/04/99 100 Vermont Metal Products Our dock UPS Ground Beth Central
Yes Net 60 Days Y N
Special msg: Deliveries are now being taken on the
east end of the building. Thank you.
------------------------------------------------------------------------------------------------------------------------------------
Seq# Our-item-# Our description Vendor-prod-# Vendor’s description Qty-ord Unit Unit-price
Worksheet # Unit-conversion Sell-UM Ship-UM Ordrd-for Ext-price
Reqd-date Ship-qty Ex-days
------------------------------------------------------------------------------------------------------------------------------------
10 1 Drill, 1/4” Power Hand 1 Drill, 1/4” Power Hand 12 EACH 22.50 EACH
1 CASE = 12 EACH EACH CASE INVENTORY 270.00
6/09/99 12 5
Note-# Text
10 If unavailable please do not substitute
Acct-# Description Quantity
Accounting distributions: 5070-000 Inventory expenses 12
1 lines Total P.O. amount = 270.00
------------------------------------------------------------------------------------------------------------------------------------
2 P.O.’s 2 total lines Grand total P.O. amount = 1,779.11
-- End of report --
Changed Purchase Orders Edit List
Date 06/04/1999 Time 15:07:51 XYZ Company Report #0193 Page 0001
C H A N G E D P U R C H A S E O R D E R S E D I T L I S T
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# PO-date Vendor Name and address F.O.B. Ship-via Ordered by Deliver-to
Cng-# Prt? Init Adrs-# Special-terms Confrm? Multi-drop
Cng-date
------------------------------------------------------------------------------------------------------------------------------------
16 6/04/99 100 Vermont Metal Products Our dock UPS Ground Beth Central
1 No RWA Net 60 Days Y N
6/04/99
Special msg: Deliveries are now being taken on the
east end of the building. Thank you.
------------------------------------------------------------------------------------------------------------------------------------
Lin# Our-item-# Our-description Vendor-prod-# Vendor’s description Qty-ord Unit Unit-price
Worksheet-# Unit-conversion Sell-UM Ship-UM Ordrd-for Ext-price
Reqd-date Ship-qty Ex-days
------------------------------------------------------------------------------------------------------------------------------------
1 1 Drill, 1/4” Power Hand 1 Drill, 1/4” Power Hand 12 EACH 22.50 EACH
1 CASE = 12 EACH EACH CASE INVENTORY 270.00
6/09/99 12 5
Note-# Text
10 If unavailable please do not substitute
Acct-# Description Quantity
Accounting distribution: 5070-000 Inventory expenses 12
HAS BEEN CHANGED TO:
===================
1 1 Drill, 1/4” Power Hand 1 Drill, 1/4” Power Hand 24 EACH 22.50 EACH
1 CASE = 12 EACH EACH CASE INVENTORY 540.00
6/09/99 24 5
Note-# Text
10 If unavailable please do not substitute
Acct-# Description Quantity
Accounting distribution: 5070-000 Inventory expenses 24
** THIS CHANGED P.O. MUST BE PRINTED BEFORE POSTING CAN OCCUR **
** POSTING NOT ALLOWED - ONE OR MORE CHANGED P.O.’S MUST BE PRINTED FIRST **
-- End of report --
Changed Purchase Orders Register
Date 06/04/1999 Time 15:09:51 XYZ Company Report #0194 Page 0001
C H A N G E D P U R C H A S E O R D E R S R E G I S T E R
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# PO-date Vendor Name and address F.O.B. Ship-via Ordered by Deliver-to
Cng-# Prt? Init Adrs-# Special-terms Confrm? Multi-drop
Cng-date
------------------------------------------------------------------------------------------------------------------------------------
16 6/04/99 100 Vermont Metal Products Our dock UPS Ground Beth Central
1 Yes RWA Net 60 Days Y N
6/04/99
Special msg: Deliveries are now being taken on the
east end of the building. Thank you.
------------------------------------------------------------------------------------------------------------------------------------
Lin# Our-item-# Our-description Vendor-prod-# Vendor’s description Qty-ord Unit Unit-price
Worksheet-# Unit-conversion Sell-UM Ship-UM Ordrd-for Ext-price
Reqd-date Ship-qty Ex-days
------------------------------------------------------------------------------------------------------------------------------------
1 1 Drill, 1/4” Power Hand 1 Drill, 1/4” Power Hand 12 EACH 22.50 EACH
1 CASE = 12 EACH EACH CASE INVENTORY 270.00
6/09/99 12 5
Note-# Text
10 If unavailable please do not substitute
Acct-# Description Quantity
Accounting distribution: 5070-000 Inventory expenses 12
HAS BEEN CHANGED TO:
===================
1 1 Drill, 1/4” Power Hand 1 Drill, 1/4” Power Hand 24 EACH 22.50 EACH
1 CASE = 12 EACH EACH CASE INVENTORY 540.00
6/09/99 24 5
Note-# Text
10 If unavailable please do not substitute
Acct-# Description Quantity
Accounting distribution: 5070-000 Inventory expenses 24
-- End of report --
Date 06/04/1999 Time 15:41:28 XYZ Company Report #0195 Page 0001
R E C E I V I N G S E D I T L I S T
Starting receiver #: “First” Ending receiver #: “Last”
“Line-for” - A line can be for INVENTORY or OTHER
For inventory items current replacement cost will be used if price is unknown
“BKT” next to P.O.# means this is a blanket P.O.
------------------------------------------------------------------------------------------------------------------------------------
Recv-# Rec-date P.O.-# P.O.-date Vendor Name ----------------Deliver-to-------------- Auth
------------------------------------------------------------------------------------------------------------------------------------
21 *** THIS RECEIVER MARKED AS VOID ***
22 *** THIS RECEIVER MARKED AS VOID ***
------------------------------------------------------------------------------------------------------------------------------------
23 6/04/99 16 6/04/99 100 Vermont Metal Products Central 300 Central Ave RWA
Line-# Item-# Item description -----Qty rec’d----- ------Unit price------ Tot-value Line-for
1 1 Drill, 1/4” Power Hand 24 EACH 22.50 EACH 540.00 INVENTORY
Delivery schedule: Date Quantity Qty-to-apply Status
06/09/99 24 24 Closed
------------------------------------------------------------------------------------------------------------------------------------
1 Receivers 2 Void receivers 1 Lines Grand total value: 540.00
-- End of report --
Date 06/04/1999 Time 15:42:03 XYZ Company Report #0196 Page 0001
R E C E I V I N G S R E G I S T E R
Cut-off receiver #: “Last”
“Line-for” - A line can be for INVENTORY or OTHER
For inventory items current replacement cost will be used if price is unknown
“BKT” next to P.O.# means this is a blanket P.O.
------------------------------------------------------------------------------------------------------------------------------------
Recv-# Rec-date P.O.-# P.O.-date Vendor Name ----------------Deliver-to-------------- Auth
------------------------------------------------------------------------------------------------------------------------------------
21 *** THIS RECEIVER MARKED AS VOID ***
22 *** THIS RECEIVER MARKED AS VOID ***
------------------------------------------------------------------------------------------------------------------------------------
23 6/04/99 16 6/04/99 100 Vermont Metal Products Central 300 Central Ave RWA
Line-# Item-# Item description -----Qty rec’d----- ------Unit price------ Tot-value Line-for
1 1 Drill, 1/4” Power Hand 24 EACH 22.50 EACH 540.00 INVENTORY
Delivery schedule: Date Quantity Qty-to-apply Status
06/09/99 24 24 Closed
------------------------------------------------------------------------------------------------------------------------------------
1 Receivers 2 Void receivers 1 Lines Grand total value: 540.00
-- End of report --
Date 06/04/1999 Time 15:48:37 XYZ Company Report #0199 Page 0001
B L A N K E T O R D E R S L I S T
P.O. range: “First” to “Last”
Ex-days = Number of days before release date that this release should be expedited
Items can be ordered for: INVENTORY or OTHER
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# P.O.-dat Vendor Name F.O.B. Ship-via Ordered-by Deliver-to
--Last release- Special-terms Rels-frequency
------------------------------------------------------------------------------------------------------------------------------------
18 6/04/99 300 Red Line Freight Our dock UPS Ground Beth Central
6/04/99 No: 01 Every 01 Weeks
------------------------------------------------------------------------------------------------------------------------------------
Lin# Our-item-# Our-description Vendor-prod-# Vendor’s description Qty-ord Unit Unit-price
Worksheet-# Unit-conversion Sell-UM Ship-UM Ordrd-for Ext-price Ex-days
------------------------------------------------------------------------------------------------------------------------------------
1 2 Hammer, 16 oz. Claw 2 Hammer, 16 oz. Claw 280 EACH 9.00 EACH
EACH EACH INVENTORY 2,520.00
Last rels: 6/04/99 10
Total qty released: 10
Balance to release: 270
Already received: 0
Account-# Description Quantity
Accounting distribution: 5070-000 Inventory expenses 280
Total P.O. amount = 2,520.00
-- End of report --
Date 06/04/1999 Time 16:02:38 XYZ Company Report #0200 Page 0001
R E L E A S E S E D I T L I S T
P.O. range: “First” to “Last” (All P.O.’s in the range are shown)
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# Release-type Prev-rls-date Vendor Name Prev-release-interval
Print? New-rls-date New-release-interval
------------------------------------------------------------------------------------------------------------------------------------
18 Add release 2 6/04/99 300 Red Line Freight Every 1 Weeks
YES 6/11/99 SAME
------------------------------------------------------------------------------------------------------------------------------------
Line# Item Description Prev-qty-ord Unit Prev-unit-price Prev-rls-qty Exp-days
New-qty-ord New-unit-price New-rls-qty
------------------------------------------------------------------------------------------------------------------------------------
1 2 Hammer, 16 oz. Claw 280 EACH 9.00 EACH 10
SAME SAME SAME
** THIS P.O. MUST BE PRINTED BEFORE POSTING CAN OCCUR **
** POSTING NOT ALLOWED - ONE OR MORE P.O.’S MUST BE PRINTED FIRST **
-- End of report --
Date 06/04/1999 Time 16:07:27 XYZ Company Report #0201 Page 0001
R E L E A S E S R E G I S T E R
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# Release-type Prev-rls-date Vendor Name Prev-release-interval
Print? New-rls-date New-release-interval
------------------------------------------------------------------------------------------------------------------------------------
18 Add release 2 6/04/99 300 Red Line Freight Every 1 Weeks
PRINTED 6/11/99 SAME
------------------------------------------------------------------------------------------------------------------------------------
Line# Item Description Prev-qty-ord Unit Prev-unit-price Prev-rls-qty Exp-days
New-qty-ord New-unit-price New-rls-qty
------------------------------------------------------------------------------------------------------------------------------------
1 2 Hammer, 16 oz. Claw 280 EACH 9.00 EACH 10
SAME SAME SAME
-- End of report --
Date 06/04/1999 Time 16:20:51 XYZ Company Report #0202 Page 0001
P R I C E A D J U S T M E N T S E D I T L I S T
------------------------------------------------------------------------------------------------------------------------------------
Recvr# Recv-dat P.O.-# Ln# Vendor Name Item-# Description Qty-recd
------------------------------------------------------------------------------------------------------------------------------------
23 6/04/99 16 1 100 Vermont Metal Products 1 Drill, 1/4” Power Hand 24 EACH
Prev price: 22.50 per EACH Prev total price: 540.00 Adjustment: 4.08- For inventory
(Temporary) New price: 22.33 per EACH New total price: 535.92
Total adjustment: 4.08-
DR to 1200-100 B/S Liab Account 4.08
CR to 5080-000 Purchase price adjustments 4.08
-- End of report --
Date 06/04/1999 Time 16:20:57 XYZ Company Report #0203 Page 0001
P R I C E A D J U S T M E N T S R E G I S T E R
------------------------------------------------------------------------------------------------------------------------------------
Recvr# Recv-dat P.O.-# Ln# Vendor Name Item-# Description Qty-recd
------------------------------------------------------------------------------------------------------------------------------------
23 6/04/99 16 1 100 Vermont Metal Products 1 Drill, 1/4” Power Hand 24 EACH
Prev price: 22.50 per EACH Prev total price: 540.00 Adjustment: 4.08- For inventory
(Temporary) New price: 22.33 per EACH New total price: 535.92
Total adjustment: 4.08-
DR to 1200-100 B/S Liab Account 4.08
CR to 5080-000 Purchase price adjustments 4.08
-- End of report --
Date 06/04/1999 Time 17:09:04 XYZ Company Report #0204 Page 0001
O P E N P U R C H A S E O R D E R S
Selections for this print-out:
1. Starting P.O.# “First”
2. Ending P.O.# “Last”
3. Starting P.O. date “Earliest”
4. Ending P.O. date “Latest”
5. Deliver-to location “All”
6. Vendor # “All”
7. Show P.O. lines ? N
8. Brief format ? N
9. Show closed lines ? (Not applicable)
10. Only P.O.’s for item (Not applicable)
Date 06/04/1999 Time 17:14:47 XYZ Company Report #0205 Page 0001
F O L L O W - U P P A S T D U E S H I P M E N T S
Due date cut-off: 6/30/99 Deliver-to location: “All” A,B,C class: “All”
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# Date Vendor Name Phone-1 Phone-2 Contact-1 Contact-2 Deliver-to
------------------------------------------------------------------------------------------------------------------------------------
15 6/04/99 100 Vermont Metal Products 802-445-9134 802-445-9136 John Smith Howard Brice Central
Line# Your/Our-item Description Unit-price Unit Qty-ordered Reqd-date Qty-to-ship Qty-received
1 7 Gauge, Hi-pressure 6.59 EACH 229 6/04/99 229 PAST DUE
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# Date Vendor Name Phone-1 Phone-2 Contact-1 Contact-2 Deliver-to
------------------------------------------------------------------------------------------------------------------------------------
18 6/04/99 300 Red Line Freight 213-768-7650 213-768-7660 Carl Rawlings Lucy Mason Central
*BLANKET ORDER*
Line# Your/Our-item Description Unit-price Unit Qty-ordered Reqd-date Qty-to-ship Qty-received
1 2 Hammer, 16 oz. Claw 9.00 EACH 280 6/11/99 10 PAST DUE
Report totals: 2 lines on 2 P.O.’s are overdue
-- End of report --
Date 06/04/1999 Time 17:20:43 XYZ Company Report #0206 Page 0001
C A S H D I S B U R S E M E N T S P R O J E C T I O N
Document types are: VCH = Voucher RCV = Uninvoiced receiving PO = Open purchase order BKT = Blanket purchase order
The as-of date is : Invoice date, for a voucher Receipt date, for a receiving Requested date, for a purchase order
Past due documents are included in the first reporting period.
“*” next to a total amount means that the total includes some uninvoiced receivings with unknown prices.
Starting vendor: “First” Ending vendor: “Last”
Report format: Detail
------------------------------------------------------------------------------------------------------------------------------------
---------------Cash required for------------ WEEK WEEK MON MON MON QTR
Doc Doc As-of Amount ending ending ending ending ending ending
typ # date 6/04/99 6/11/99 7/11/99 8/11/99 9/11/99 12/11/99
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 100 Vermont Metal Products
----------------------------------------
VCH 1061 1/24/99 965.60 966
VCH 1071 1/24/99 925.00 925
VCH 1074 1/28/99 3,500.00 3,500
VCH 1075 1/27/99 2,350.55 2,351
VCH 1083 3/10/99 125.60 126
VCH 1085 3/10/99 399.34 399
RCV 23 6/04/99 UNKNOWN
PO 15 6/04/99 1,509.11 1,509
Vendor 100 totals: 9,775.20
8,267 1,509 *
Vendor: 200 Acme Office Supplies
----------------------------------------
VCH 1059 1/22/99 1,625.00 1,625
VCH 1062 1/23/99 2,500.75 2,501
VCH 1073 1/23/99 2,097.50 2,098
Vendor 200 totals: 6,223.25
6,224
Vendor: 400 Jones Property Management
----------------------------------------
VCH 1064 1/23/99 11,000.00 11,000
Vendor 400 totals: 11,000.00
11,000
Date 06/04/1999 Time 17:20:43 XYZ Company Report #0206 Page 0002
C A S H D I S B U R S E M E N T S P R O J E C T I O N
------------------------------------------------------------------------------------------------------------------------------------
---------------Cash required for------------ WEEK WEEK MON MON MON QTR
Doc Doc As-of Amount ending ending ending ending ending ending
typ # date 6/04/99 6/11/99 7/11/99 8/11/99 9/11/99 12/11/99
------------------------------------------------------------------------------------------------------------------------------------
Vendor: 500 E-Z Repairs
----------------------------------------
VCH 1065 1/22/99 875.00 875
Vendor 500 totals: 875.00
875
Vendor: 600 Wells Fargo Bank
----------------------------------------
VCH 1066 1/22/99 65.00 65
Vendor 600 totals: 65.00
65
Vendor: 700 Pacific Telephone
----------------------------------------
VCH 1067 1/25/99
Vendor: 800 Hanson Manufacturing Co.
----------------------------------------
VCH 1057 1/23/99 1,275.00 1,275
VCH 1060 1/24/99 365.00 365
VCH 1068 1/25/99 560.79 561
VCH 1072 1/24/99 2,155.00 2,155
Vendor 800 totals: 4,355.79
4,356
Vendor: 1000 Greener Grass Ofc. Plants
----------------------------------------
VCH 1058 1/25/99 2,965.00 2,965
VCH 1070 1/24/99 8,540.00 8,540
Vendor 1000 totals: 11,505.00
11,505
Report totals: 46,732.22 360 1,170
Date 06/04/1999 Time 17:20:43 XYZ Company Report #0206 Page 0003
C A S H D I S B U R S E M E N T S P R O J E C T I O N
------------------------------------------------------------------------------------------------------------------------------------
---------------Cash required for------------ WEEK WEEK MON MON MON QTR
Doc Doc As-of Amount ending ending ending ending ending ending
typ # date 6/04/99 6/11/99 7/11/99 8/11/99 9/11/99 12/11/99
------------------------------------------------------------------------------------------------------------------------------------
42,885 1,869 * 450
-- End of report --
Date 06/04/1999 Time 17:41:25 XYZ Company Report #0207 Page 0001
C L O S E D P U R C H A S E O R D E R S
Selections for this print-out:
1. Starting P.O.# “First”
2. Ending P.O.# “Last”
3. Starting P.O. date “Earliest”
4. Ending P.O. date “Latest”
5. Deliver-to location “All”
6. Vendor # “All”
7. Show P.O. lines ? N
8. Brief format ? N
9. Only P.O.’s for item (Not applicable)
Date 06/04/1999 Time 17:41:25 XYZ Company Report #0207 Page 0001
C L O S E D P U R C H A S E O R D E R S
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# PO-date Vendor Name and address F.O.B. Ship-via Ordered-by Deliver-to
Lst-cng Cng-date Special terms Opn lins/Clsd lins
------------------------------------------------------------------------------------------------------------------------------------
16 6/04/99 100 Vermont Metal Products Our dock UPS Ground Beth Central
1 6/04/99 410 Pinecrest Road Net 60 Days 0 1
Newton VT 12345
Special msg: Deliveries are now being taken on the
east end of the building. Thank you.
-- End of report --
Date 06/04/1999 Time 17:45:55 XYZ Company Report #0208 Page 0001
R E C E I V I N G S H I S T O R Y
Starting P.O.#: “First” Starting receipt date: “Earliest”
Ending P.O.#: “Last” Ending receipt date: “Latest”
For deliver-to location: “All”
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# Vendor Name Ln# Item-# Unit Qty-ord Recvr# Recv-dat Qty-recd Tot-value Stat Id
------------------------------------------------------------------------------------------------------------------------------------
16 100 Vermont Metal Products 1 1 EACH 24 23 6/04/99 24 535.92 CLSD RWA
Report total value: 535.92
-- End of report --
Purchase Order Distribution Report
Date 06/07/1999 Time 10:41:22 XYZ Company Report #0209 Page 0001
P U R C H A S E O R D E R D I S T R I B U T I O N R E P O R T
Outstanding dist $ includes goods ordered but not received plus goods received but not invoiced
“(B)” following the PO number indicates a blanket order
“*” next to the line # means that the line is closed
Account: 5070-000 Inventory expenses Starting P.O. date: “Earliest” Ending P.O. date: “Latest”
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# Vendor Deliver-to Line# Our-item-# Description Lin-qty-ord Unit Orig-dist-$ Outst-dist-$
P.O.-date Name Lin-qty-rcd Qty-released Outst-rlsd-$
------------------------------------------------------------------------------------------------------------------------------------
15 100 Central 1 7 Gauge, Hi-pressure 229 EACH 1,509.11 1,509.11
6/04/99 Vermont Metal Products 0
16 100 Central 1* 1 Drill, 1/4” Power Hand 24 EACH 540.00 540.00
6/04/99 Vermont Metal Products 24
18 (B) 300 Central 1 2 Hammer, 16 oz. Claw 280 EACH 2,520.00 2,520.00
6/04/99 Red Line Freight 0 20 180.00
5070-000 Account total: 4,569.11 4,569.11
-- End of report --
Date 06/07/1999 Time 10:51:24 XYZ Company Report #0210 Page 0001
U N I N V O I C E D R E C E I V I N G S
Receiving cut-off date: 6/07/99
“*” next to unit price indicates that the exact price is not yet known
------------------------------------------------------------------------------------------------------------------------------------
Recv-# P.O.-# Ln# Recv-dat Vendor Name Item-#/Descr Qty-received Unit Unit-price Total-price
------------------------------------------------------------------------------------------------------------------------------------
23 16 1 6/04/99 100 Vermont Metal Products 1 24 EACH 22.33 * 535.92
Drill, 1/4” Power Hand
Total uninvoiced receivings: 535.92
Uninvoiced receivings distribution: Account-# Description Amount
5070-000 Inventory expenses 540.00
Total uninvoiced receivings distributions: 540.00
*** Difference between totals due to over/under receivings or price change ***
-- End of report --
Date 06/07/1999 Time 10:55:04 XYZ Company Report #0211 Page 0001
U N K N O W N P R I C E S
New price must be for same unit as the quantity received
------------------------------------------------------------------------------------------------------------------------------------
Recv-# P.O.-# Ln# Recv-dat Vendor Name Item-#/Descr Qty-received Unit Unit-price New-price
------------------------------------------------------------------------------------------------------------------------------------
23 16 1 6/04/99 100 Vermont Metal Products 1 24 EACH 22.33 _____________
Drill, 1/4” Power Hand
-- End of report --
Date 06/07/1999 Time 11:31:31 XYZ Company Report #0212 Page 0001
P U R C H A S E O R D E R P U R G E R E P O R T
Cut-off P.O. number: “Last” Cut-off P.O. date: “Latest”
------------------------------------------------------------------------------------------------------------------------------------
P.O.-# PO-date Vendor Name F.O.B. Ship-via Ordered-by Deliver-to
------------------------------------------------------------------------------------------------------------------------------------
15 6/04/99 - Cannot be purged because one or more lines are open
16 6/04/99 - Cannot be purged due to uninvoiced receivings
18 6/04/99 - Cannot be purged because one or more lines are open
-- End of report --